Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
Hello,
This might be a very basic question, but I cannot figure it out.
I have the following information (redacted) in Table_1:
ID: Grant_Date:
001 1 January 2021
002 1 March 2021
003 1 February 2021
I have a master date table as well.
I want to write a DAX measure in order to achieve the following on a Matrix:
(the Master Date is inserted as the "Columns" on the Matrix and the ID is inserted as the "Rows". I need a measure for the "values" in red below)
ID: | 30 April 2021 | 31 May 2021 | 30 June 2021 | 31 July 2021 |
001 | 120 | 151 | 181 | 212 |
002 | 61 | 92 | 122 | 153 |
003 | 89 | 120 | 150 | 181 |
Solved! Go to Solution.
Hi @JohannSteyn
Try this:
measure=
Var _MGD = MAX(Table_1[Grant_Date])
Var _MDD = MAX(Master Date[Date])
return
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Hi @JohannSteyn
Try this:
measure=
Var _MGD = MAX(Table_1[Grant_Date])
Var _MDD = MAX(Master Date[Date])
return
If this post helps, please consider accepting it as the solution to help the other members find it more quickly.
Appreciate your Kudos!!
LinkedIn: www.linkedin.com/in/vahid-dm/
Thank you!
User | Count |
---|---|
120 | |
65 | |
62 | |
56 | |
50 |
User | Count |
---|---|
177 | |
85 | |
70 | |
63 | |
55 |