Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Techies,
Please help me in following scenario.
I have two tables with following values
Date | ResultDate |
31-May | 29-Feb |
31-May | 31-Mar |
31-May | 30-Apr |
30-Jun | 31-Mar |
30-Jun | 30-Apr |
30-Jun | 31-May |
31-Jul | 30-Apr |
31-Jul | 31-May |
31-Jul | 30-Jun |
31-Aug | 31-May |
31-Aug | 30-Jun |
31-Aug | 31-Jul |
Date | Values |
31-Jan | 1 |
31-Jan | 2 |
29-Feb | 3 |
31-Mar | 4 |
31-Mar | 5 |
30-Apr | 6 |
31-May | 7 |
31-May | 8 |
31-May | 9 |
30-Jun | 10 |
30-Jun | 11 |
31-Jul | 12 |
31-Jul | 13 |
31-Aug | 14 |
I need output as following
ResultDate | value |
29-Feb | 3 |
31-Mar | 9 |
30-Apr | 6 |
31-Mar | 9 |
30-Apr | 6 |
31-May | 24 |
30-Apr | 6 |
31-May | 24 |
30-Jun | 21 |
31-May | 24 |
30-Jun | 21 |
31-Jul | 25 |
I have created on date table which has unique dates and created relationships in between table 1 and date table, table 2 and date table, still it is not giving me expected output.
Please help me.
Thanks in advance.
Regards,
Pooja Darbhe
Hi @PoojaDarbhe ,
Could you explain what each column of data represents?
What is the relationship between them?
What is the calculation logic?
Best Regards,
Icey
@PoojaDarbhe , what is the relation between 1st and second. Two me it seems like sum from table 2 but repeated
actually I want the output on selection of the date. but when I select any date in sclicer it will not giving the output as expected, i.e. if I select "31 May" in slicer then I want to show on bar chart the values as result date on x axis and its corresponding values on y axis like describe below.
29 Feb - 3
31 Mar - 9
30 Apr - 6
Let me know if you want any more information, please suggest something what can I do.
Thanks and regards,
Pooja Darbhe
@PoojaDarbhe , Based on what I got you to need something like
Meausure =
var _max =maxx(allselected(date),date[date])
return
CALCULATE(SUM(Sales[Sales Amount]),filter(all(date),date[date]<=_max))
Also, refer as date might group into one date : https://www.youtube.com/watch?v=duMSovyosXE
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
62 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |