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

So my goal was to calculate the difference. I used Prv_Qtr_Assets = CALCULATE(sum ('Income Statement $'[Average Assets]), DATEADD('Income$MasterDate'[Date].[Date],-1,QUARTER)) this command to get side by side values for Assets but its not working as the column remains blank. 

 

If there was  value my hope was that I can just deduct one column from the other. Am I on right track?