Forum Discussion
Days difference between two date in a measure
Hello Everyone!!
I am trying to calculate a measure in which i am trying to calculate date difference between two coloumns that are present in seperate diffrent tables in star schema. One is date Dimension in which last date of each month is present and the other is accumulating fact table in which dates are present with respect to work flow.
Now what I am trying to do is to get date difference of one date coloumn from fact table to that of data coloumn from date dimension.
currently i am using this dax farmula
which is giving me wrong result
kindly help me out .
Anonymous , Is the date table joined with Fact RC date ?
Because then it will same date
In a measure to take a date diff you need three thing
1 . Min of smaller date
2. Max of bigger date
3. A common group by (In this case it may be an Id from fact), That is forced using values or summarize
refer to my blog - https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
1 Reply
- amitchandak
Super User
Anonymous , Is the date table joined with Fact RC date ?
Because then it will same date
In a measure to take a date diff you need three thing
1 . Min of smaller date
2. Max of bigger date
3. A common group by (In this case it may be an Id from fact), That is forced using values or summarize
refer to my blog - https://community.powerbi.com/t5/Community-Blog/Decoding-Direct-Query-in-Power-BI-Part-2-Date-Difference-Across/ba-p/934397#M451
or
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.