Forum Discussion

PowerBi2bPro's avatar
PowerBi2bPro
Icon for Helper I rankHelper I
2 years ago

Date Function or DAX that returns value from a specific column

Hi Everyone,   I am looking to get some direction. I am new to this forum and Power BI. I am sharing an example of the table to explain my question.   I have a dataset that has quarterly data for...
PowerBi2bPro's avatar
PowerBi2bPro
Icon for Helper I rankHelper I
2 years ago

Thank you so much for sharing your thoughts. I have specific dates such as Dec 31 2023 that I am using as Quarter start/end date.  I am having hard time explaining this. I will try again...

 

So date Columns has following entries

 

31 Dec 2023

30 Sep 2023

 

Expense Column has the following cooresponsing entries

 

15,000

10,000

 

Now lets say we wanted to know the difference between Sep and December expense. In this case it would be 5,000 

 

How can I do this in Power BI?

 

talespin's avatar
talespin
Icon for Solution Sage rankSolution Sage
2 years ago

hi PowerBi2bPro ,

 

Create a Date table, this table should have all the dates(all dates from Min of your date column to maximum of date column), along with any other necessary columns like month, year.

Join this table to your table on Date column(Make sure data type is date).

Something like this

VAR _MinDate = MIN(Date column)
VAR _MaxDate = MAX(Date column)
CALENDAR(_MinDate, _MaxDate)

 

Then use the Measure.