iStore Info

This Blog to Store All Information Related to Oracle EBS Apps, Useful Applications, Latest Technology.

Recent Posts

The best free collage maker 2020: www.photocollage.com

Combine your favorite photos with a free collage maker With a free photo collage maker, transforming your photos into a work of art is fun a...

Top 5 Free Conditional Logic Form Plugins for Wordpress

What is Conditional Logic Form? Conditional logic form or conditional fields form is nothing but the form with conditional fields. Condition...

Display Last Refreshed Date in Power BI

Display the Last Refreshed Date in Power BI Generate Last Refreshed Date with Power Query Unlike the previous article, to work with Power BI...

How to use IF Condition DAX Formula in Power BI

IF Checks if a condition provided as the first argument is met. Returns one value if the condition is TRUE, and returns another value if ...

How to convert positive number to negative in Power BI

Column = IF(ConvertedMonthlyPrice] < 0 , [NumberOfUsers] * -1 , [NumberOfUsers] )

How to add days to date in power bi

Date.AddDays 07/29/2019 2 minutes to read       Syntax Date.AddDays( dateTime as any, numberOfDays as number) as any A...

Quickly create Week, Month, Quarter, and Year fields from a date using DAX in POWER BI

It’s rare to come across a report or data set that does not slice by time. While it’s necessary for virtually all reports, analysts often ...

How to Format Dates in Power BI with an example?

Credits to -  https://www.tutorialgateway.org/ How to Format Dates in Power BI To demonstrate these Power BI date formats, we are goi...

Oracle EBS Average Cost Update Formula

Average Cost Update Formula Average Cost =    ( Transaction Value+Current Inventory value)                            (Transaction ...

Power BI Tips: Import vs Direct Query

Microsoft Power BI is a self-service Business Intelligence tool that lets you connect to multiple different data sources – Power BI offers...

Query to Find Requisition Number from Purchase Order Number

Query to find the purchase order number from requisition number: SELECT DISTINCT pha.segment1 FROM po_headers_all pha,po_distributions_all ...

Complete SQL query uses Customer base tables in oracle apps R12

Customer base tables in oracle apps r12 In this post , We will discuss about Technical tables uses to store customer information's i...