The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello,
I am having difficulty creating a DAX table from an imported table. Basically, what I am trying to achieve is what a VLOOKUP TRUE would achieve in Excel in an effort to create a contiguous date table with values. I can then reference this table using a concatenated reference ItemDate from another table. Here is the input and output sample. Please advise if there is a more efficient alternative to this approach.
Solved! Go to Solution.
@Anonymous
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Find-last-value-based-on-date/m-p/293150#M129228
@Anonymous
You may refer to the post below.
https://community.powerbi.com/t5/Desktop/Find-last-value-based-on-date/m-p/293150#M129228
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
95 | |
51 | |
50 | |
46 |