Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
i have a calendar 1 jan 2017 till 31 dec 2019 connected with a source which is split by months, but also i created a fake date - as first date of each month-year to make connection with calendar
now i need for a measure to count days in a graph depending of year and months selection
so if i select jan-feb 2019 i need to have 59 (31+28)
if the graph is split by months, i need to have for jan 31 and feb 28
Now count return only 1 for a month, probably due to fake date from source
Thanks,
Cosmin
Solved! Go to Solution.
Hi @cosminc
You may add the YearMonth column for your calendar table and fake table.Then link them in relationship.Use date hierarchy for date column to expend the graph.
YearMonth = FORMAT('Calendar'[Date],"MMM YYYY")
Regards,
Cherie
Hi @cosminc
You may add the YearMonth column for your calendar table and fake table.Then link them in relationship.Use date hierarchy for date column to expend the graph.
YearMonth = FORMAT('Calendar'[Date],"MMM YYYY")
Regards,
Cherie
Hi
if i apply your solution there will be many to many relationship; on my base i have thousands of each month-year
Thanks,
Cosmin
Hi @cosminc
You may also delete the fake data table and just use calendar table's YearMonth column as slicer.If it is not your case,please share your sample data which could reproduce your scenario and your desired output.You can upload the .pbix file to OneDrive and post the link here. Do mask sensitive data before uploading.
Regards,
Cherie
my question was regarding that it will be a relationship many to many between the 2 bases - calendar and source
is it ok?
thanks,
Cosmin
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
111 | |
95 | |
80 | |
68 | |
59 |
User | Count |
---|---|
150 | |
119 | |
104 | |
87 | |
67 |