Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now
Hello everybody,
I have two tables (CDE and FAC). A order table (CDE), and an invoice table (FAC). Each with two date and ID columns. I would like to display in a visual only the ID with dates of orders (CDE) higher than the dates of FAC. Thank you
Have a good day
Solved! Go to Solution.
Create a calculated column in your CDE table:
Column = IF('CDE'[Date] > MAX('FAC'[Date])) , 'CDE'[Date] , BLANK())
Then filter on theat column <> Blank()
Create a calculated column in your CDE table:
Column = IF('CDE'[Date] > MAX('FAC'[Date])) , 'CDE'[Date] , BLANK())
Then filter on theat column <> Blank()
Thank you so much
Check out the October 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
113 | |
96 | |
92 | |
84 | |
69 |
User | Count |
---|---|
160 | |
125 | |
116 | |
110 | |
95 |